The following rules apply when pasting data without preserving the original formatting:

•Only the text is pasted from the clipboard. For example, when you paste a shape with text or a link, only the text that these objects contain is pasted into the document.

•If the clipboard contains a formula, only the result of the formula is pasted.

To paste data without the original formatting, follow the steps below:

1.Select the place where you want to paste the data:

•If the clipboard contains data from a single cell/row/column, select the cell/row/column where you want to paste the data.

•If the clipboard contains a range of cells/rows/columns, select the appropriate size range or select the cell/row/column where you want to paste the contents of the first cell/row/column in the range.

•If the clipboard contains an object with text, select the cell into which you want to paste the text.

2.Run the insert command in one of the following ways:

•On the Home tab, in the Edit group, click the arrow to the right of the  Paste button. In the drop-down list, select Paste values only.

•When working in macOS, select the Edit > Paste values only command from the command menu.

•Right-click the selected cells or the contents of the selected rows/columns to open the context menu. Select Paste values only from the context menu.

•Press Alt+Shift+V (Windows, Linux) or  Option+ Shift+V (macOS).